package com.adminserver.mapper;
import java.util.Date;

import com.adminserver.entity.RepairOrdersEntity;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Param;

import java.util.List;
import java.util.Map;

/**
 * @author anonymous
 * @description 针对表【repair_orders(报修订单)】的数据库操作Mapper
 * @createDate 2022-04-18 19:50:05
 * @Entity com.adminserver.entity.RepairOrdersEntity
 */
public interface RepairOrdersMapper extends BaseMapper<RepairOrdersEntity> {

    /**
     * 查询年度报修统计
     * @param beginOfYear
     * @param endOfYear
     * @return
     */
    List<Map<String, Object>> queryAnnualRepairStatist(@Param("beginOfYear") String beginOfYear,
                                                       @Param("endOfYear") String endOfYear);

    /**
     * 查询年度报修趋势（
     * @param beginOfYear
     * @param endOfYear
     * @return
     */
    List<Map<String, Object>> queryAnnualRepairTrend(@Param("beginOfYear") String beginOfYear,
                                                     @Param("endOfYear") String endOfYear);

    /**
     * 查询指定时间段内的所有订单信息
     * @param beginRepairDate
     * @param endRepairDate
     * @return
     */
    List<RepairOrdersEntity> queryAllByRepairDateBetween(@Param("beginRepairDate") String beginRepairDate,
                                                         @Param("endRepairDate") String endRepairDate);
}





